South
Seattle
Community
College
First Step Program
Business Computer Class


    
  Home Overview Coursework Tests Links Contact  

UNIT PLANS & DOWNLOADS

 Basics & Web   Word   Windows & Email   PowerPoint   Excel   QuickBooks   Integration 


Unit 4: Microsoft Excel

Read: Excel Units in Office 2003 book (pp. 96-113, 122-137, 146-161)

Topics: Entering Text/Data, Formatting Worksheets, Formulas, Functions, Creating Charts, Working with Lists (Sort, Filter)

Projects: Invoice, Office Supply Budget, Payroll, Data Presentation using Charts, Data Analysis using Lists

Downloads:
Excel Topics
Excel Written Formula Exercise
Excel HW Projects + Donor List for Sort & Filter Project
In-class invoice & chart exercises
In-class sort & filter exercises
Group Exercise 1 (see handout)
Group Exercise 2 (p.141-142 - independent challenge 2)
Group Exercise 3 (p.142-143 - independent challenge 3)
Group Exercise 4 (p.144 - visual workshop)
Group Exercise 5 (p.165-166 - independent challenge 2)
Group Exercise 6 (p.166-167 - independent challenge 3)
Group Exercise 7 (no download) (p.143 - independent challenge 4)

Extra Credit Project 2: Instructions and Data File


* Note: Each quarter is a little different, so there will be some changes to these projects as we go.